package com.saas.sql;

public class Deleted
{
  public static final String dele_SEL_SPEC_DEL_KEY = "select s.* from tf_f_infolist_del d ,tf_f_sale s where d.info_id = s.sale_id and s.sale_type=:VSALE_TYPE";
  public static final String dele_SEL_SPEC_DELE_DATE_T = "select * from tf_f_infolist_del d ,tf_f_sale s where d.info_id = s.sale_id and d.pub_date between :VSTART_DATE and :VEND_DATE order by d.pub_date desc";
  public static final String dele_SEL_SPEC_DEL_BYKEY = "select * from tf_f_infolist_del d,tf_f_sale s where d.info_id=s.sale_id and d.title like :VKEY_WORD ";
  public static final String dele_SEL_DEL_PRO_ALL = "select p.PRODUCT_ID,p.PRODUCT_NAME,p.PRODUCT_DESC,p.PRODUCT_SITE,p.AUDIT_DATE from tf_f_product p, tf_f_infolist_del d where p.product_id =d.info_id";
  public static final String dele_SEL_DEL_PRO_ALL_BYLIKE = "select p.PRODUCT_ID,p.PRODUCT_NAME,p.PRODUCT_DESC,p.PRODUCT_SITE,p.AUDIT_DATE from tf_f_product p, tf_f_infolist_del d where p.product_id =d.info_id and p.PRODUCT_DESC like :VPRODUCT_NAME";
}

